protocol=sql
host=localhost
port=4334

### Postgres
sql-url=jdbc:
sql-user=datomic
sql-password=datomic
sql-driver-class=org.postgresql.Driver

user>   (d/create-database "datomic:)
true
user>   (d/connect "datomic:)
ClassCastException   [trace missing]

(def User
  "A schema for a User entity"
  {(s/required-key :user/full-name)           Text
   (s/optional-key :user/nickname)            Text
   (s/required-key :user/email)               Email
   (s/required-key :user/status)              (s/enum :status/active
                                                      :status/suspended
                                                      :status/deleted)
…

(d/q '[:find (min ?t) . :in $ $h ?e :where
             [$h ?e _ _ ?tx]
             [?tx :db/txInstant ?t]]
           db
           (d/history db)
           (:db/id (d/entity db [:attr "value"])))

(let [entity (->> (d/q '[:find ?e .
                              :where [?e :db/ident ]]
                         (d/db conn))
                    (d/entity (d/db conn))
                    d/touch)]
    (assoc entity :answer 42) )

(let [entity (->> (d/q '[:find ?e .
                     :where [?e :db/ident]]
                   (d/db conn))
              (d/entity (d/db conn))
              d/touch
              (into {}))]
  (assoc entity :answer 42))

(d/q '[:find ?e ?unique-ident
       :in $ ?a ?v
       :where
       [?e ?a ?v]
       [?a :db/unique ?unique]
       [?unique :db/ident ?unique-ident]]
     (d/db (db/connection))
     :cat.block/key
     "designers22")

->

[[17592187845110 :db.unique/identity]
,[17592189560149 :db.unique/identity]]

(d/q '[:find (pull ?e [{:row/_columns [:db/id]}]) . :in $ ?e] db 277076930201266)

(d/q '[:find (pull ?e [* {:row/_columns [:db/id]}]) . :in $ ?e] db 277076930201266)

user=> (:row/_columns (d/q '[:find (pull ?e [{:row/_columns [:db/id]}]) . :in $ ?e] db 277076930201266))
[{:db/id 277076930201265}]
user=> (:row/_columns (d/q '[:find (pull ?e [* {:row/_columns [:db/id]}]) . :in $ ?e] db 277076930201266))
nil

java.lang.RuntimeException: No reader function for tag db/id

[
 {
  :db/id #db/id[:db.part/user]
  :db/ident :company/name
  :db/valueType :db.type/string
  :db/cardinality :db.cardinality/one
  :db/unique :db.index/value
  :db/doc "The name of the company"
  :db.install/_attribute :db.part/db
  }
 ]

(read-string (slurp "resources/schemas/company.edn"))

(d/tempid :db.part/user)

#db/id[:db.part/user]

[{:db/id 3
     :components [[:metrics "Metrics" ["Productivity"
                                       "Leadership"
                                       "Happiness"]]
                  [:ol "Achievements" ["Won the spelling bee."]]
                  [:ol "Weaknesses"]
                  [:ol "Coach goals"]
                  [:ol "Player goals"]
                  [:textarea "Coach comments"]
                  [:textarea "Player comments"]]}])

java.lang.NullPointerException: null
	at datomic.db$get_ids$fn__4004.invoke(db.clj:2352) ~[datomic-transactor-pro-0.9.5186.jar:na]
	at clojure.core.protocols$fn__6074.invoke(protocols.clj:79) ~[clojure-1.6.0.jar:na]
	at clojure.core.protocols$fn__6031$G__6026__6044.invoke(protocols.clj:13) ~[clojure-1.6.0.jar:na]
	at clojure.core$reduce.invoke(core.clj:6289) ~[clojure-1.6.0.jar:na]
	at datomic.db$get_ids.invoke(db.clj:2367) ~[datomic-transactor-pro-0.9.5186.jar:na]
	at datomic.db.ProcessExpander.getData(db.clj:2425) ~[datomic-transactor-pro-0.9.5186.jar:na]
	at datomic.update$processor$fn__10124$fn__10125$fn__10126$fn__10130$fn__10133$fn__10134.invoke(update.clj:246) ~[datomic-transactor-pro-0.9.5186.jar:na]
	at clojure.lang.Atom.swap(Atom.java:37) ~[clojure-1.6.0.jar:na]
	at clojure.core$swap_BANG_.invoke(core.clj:2232) ~[clojure-1.6.0.jar:na]
	at datomic.update$processor$fn__10124$fn__10125$fn__10126$fn__10130$fn__10133.invoke(update.clj:240) ~[datomic-transactor-pro-0.9.5186.jar:na]
	at datomic.update$processor$fn__10124$fn__10125$fn__10126$fn__10130.invoke(update.clj:238) ~[datomic-transactor-pro-0.9.5186.jar:na]
	at datomic.update$processor$fn__10124$fn__10125$fn__10126.invoke(update.clj:235) [datomic-transactor-pro-0.9.5186.jar:na]
	at datomic.update$processor$fn__10124$fn__10125.invoke(update.clj:216) [datomic-transactor-pro-0.9.5186.jar:na]
	at datomic.update$processor$fn__10124.invoke(update.clj:216) [datomic-transactor-pro-0.9.5186.jar:na]
	at datomic.update$processor.doInvoke(update.clj:216) [datomic-transactor-pro-0.9.5186.jar:na]
	at clojure.lang.RestFn.applyTo(RestFn.java:139) [clojure-1.6.0.jar:na]
	at clojure.core$apply.invoke(core.clj:626) [clojure-1.6.0.jar:na]
	at datomic.update$background$proc__10046.invoke(update.clj:58) [datomic-transactor-pro-0.9.5186.jar:na]
	at clojure.lang.AFn.run(AFn.java:22) [clojure-1.6.0.jar:na]
	at java.lang.Thread.run(Thread.java:745) [na:1.7.0_55]

(let [db (d/db conn)]
  (clojure.pprint/pprint
    (map #(->> % (d/entity db) d/touch)
      (d/q '[:find [?a ...]
             :where [_ :db.install/attribute ?a]]
         db))))

sql-url=jdbc:
sql-user=datomic
sql-password=datomic

--max-redirect=number

{:db/id :foo
 :db/ident :bar}

:app/v3 {:txes [[{:db/id :foo
           :db/ident :bar}]]}

(ns datomic-manual-tests.mem-schema-alteration
  (:require [datomic.api :as d]))

(def db-uri "datomic:")
(d/create-database db-uri)
(def conn (d/connect db-uri))

(def schema [{:db/id (d/tempid :db.part/db)
              :db/ident :person/name
              :db/valueType :db.type/string
              :db/cardinality :db.cardinality/one
              :db.install/_attribute :db.part/db}])
@(d/transact conn schema)

(def pname-id
  (-> (d/db conn)
      (d/pull [:db/id] :person/name)
      :db/id))

(def alter-tx [{:db/id :person/name
                :db/ident :person/first-name
                :db.alter/_attribute :db.part/db}])
@(d/transact conn alter-tx)

(-> (d/pull (d/db conn) [:db/ident] pname=id)
    :db/ident)
; :person/first-name

java.lang.IllegalArgumentException: :db.error/invalid-attribute Schema change must be followed by :db.install/attribute or :db.alter/attribute […]

{:app/v1
 {:txes [[{...}

          {...}]]}

 :app/v2
 {:txes [[{...}]]}}

@(d/transact conn
             [[:db/add (d/tempid :db.part/tx) :your.domain/timestamp ts]
              ... ])

db.part/tx

2015-07-30 11:58:23.370 INFO  default    datomic.index - {:tid 150, :I 5265000.0, :index :eavt, :phase :end, :TI 8465930.540997842, :pid 1480, :event :index/merge-mid, :count 2110, :msec 14400.0, :S -283878.0409978423, :as-of-t 961005}

2015-07-30 13:15:47.572 INFO  default    datomic.process-monitor - {:tid 13, :AlarmIndexingFailed {:lo 1, :hi 1, :sum 4, :count 4}, :CreateEntireIndexMsec {:lo 16500, :hi 18600, :sum 70500, :count 4}, :MemoryIndexMB {:lo 0, :hi 0, :sum 0, :count 1}, :StoragePutMsec {:lo 1, :hi 239, :sum 11097, :count 381}, :AvailableMB 2640.0, :IndexWriteMsec {:lo 1, :hi 659, :sum 35259, :count 381}, :RemotePeers {:lo 1, :hi 1, :sum 1, :count 1}, :HeartbeatMsec {:lo 5000, :hi 5346, :sum 60427, :count 12}, :Alarm {:lo 1, :hi 1, :sum 4, :count 4}, :StorageGetMsec {:lo 0, :hi 124, :sum 2204, :count 305}, :pid 1480, :event :metrics, :StoragePutBytes {:lo 103, :hi 4568692, :sum 128385966, :count 382}, :ObjectCache {:lo 0, :hi 1, :sum 231, :count 536}, :MetricsReport {:lo 1, :hi 1, :sum 1, :count 1}, :StorageGetBytes {:lo 1853, :hi 4568435, :sum 95278692, :count 305}}
2015-07-30 13:16:47.573 INFO  default    datomic.process-monitor - {:tid 13, :TransactionDatoms {:lo 3, :hi 3, :sum 3, :count 1}, :AlarmIndexingFailed {:lo 1, :hi 1, :sum 3, :count 3}, :GarbageSegments {:lo 2, :hi 2, :sum 4, :count 2}, :CreateEntireIndexMsec {:lo 15800, :hi 17400, :sum 50500, :count 3}, :MemoryIndexMB {:lo 0, :hi 0, :sum 0, :count 1}, :StoragePutMsec {:lo 1, :hi 291, :sum 11173, :count 474}, :TransactionBatch {:lo 1, :hi 1, :sum 1, :count 1}, :TransactionBytes {:lo 102, :hi 102, :sum 102, :count 1}, :AvailableMB 2460.0, :IndexWriteMsec {:lo 2, :hi 350, :sum 36373, :count 471}, :RemotePeers {:lo 1, :hi 1, :sum 1, :count 1}, :HeartbeatMsec {:lo 5000, :hi 5003, :sum 60006, :count 12}, :Alarm {:lo 1, :hi 1, :sum 3, :count 3}, :StorageGetMsec {:lo 0, :hi 100, :sum 2151, :count 351}, :TransactionMsec {:lo 19, :hi 19, :sum 19, :count 1}, :pid 1480, :event :metrics, :StoragePutBytes {:lo 86, :hi 4568692, :sum 146567666, :count 473}, :LogWriteMsec {:lo 8, :hi 8, :sum 8, :count 1}, :ObjectCache {:lo 0, :hi 1, :sum 247, :count 598}, :MetricsReport {:lo 1, :hi 1, :sum 1, :count 1}, :PodUpdateMsec {:lo 2, :hi 7, :sum 9, :count 2}, :StorageGetBytes {:lo 86, :hi 4568435, :sum 94665879, :count 351}}

015-07-30 13:31:43.668 WARN  default    datomic.update - {:tid 77, :pid 10386, :message "Index creation failed", :db-id "canary-f3e9a40e-2036-4ad9-aae7-52919cced434"}
java.lang.OutOfMemoryError: Java heap space

# Recommended settings for -Xmx4g production usage.
 memory-index-threshold=32m
 memory-index-max=512m
 object-cache-max=1g

datomic=> SELECT pg_database.datname,
       pg_size_pretty(pg_database_size(pg_database.datname)) AS size
  FROM pg_database;
  datname   |  size
------------+---------
 template1  | 6314 kB
 template0  | 6201 kB
 postgres   | 6314 kB
 canary-web | 7002 kB
 datomic    | 51 GB
(5 rows)

user=> (d/pull db '[* {:db/cardinality [:db/ident]} {:db/valueType [:db/ident]}] :server/last-heartbeat-at)
{:db/index false, :db/valueType {:db/ident :db.type/instant}, :db/noHistory false, :db/isComponent false, :db/fulltext false, :db/cardinality {:db/ident :db.cardinality/one}, :db/doc "", :db/id 158, :db/ident :server/last-heartbeat-at}
user=> (d/q '[:find ?e ?hb :in $ ?e :where [?e :server/last-heartbeat-at ?hb]] db 17592186962108)
#{[17592186962108 #inst "2015-07-31T23:45:01.167-00:00"] [17592186962108 #inst "2015-08-01T00:45:01.195-00:00"]}
user=>

(d/q '[:find [(max ?a) ...]
       :where [?e :a ?a]]
     [[1 :a 10]
      [2 :a 20]
      [3 :a 30]])
=> [30]

(d/q '[:find [(max ?a) ?e]
       :where [?e :a ?a]]
     [[1 :a 10]
      [2 :a 20]
      [3 :a 30]])
=> [10 1]

This is to arbitrarily support extra generating options, including the new index-all? option, which flags every attribute in the schema for indexing (in line with Stuart Halloway's recommendation that you simply turn indexing on for every attribute by default).

{:db/error :db.error/incompatible-schema-install, :entity :ping.reply/start, :attribute :db/index, :was false, :requested true}

#object[datomic.promise$settable_future$reify__6754 0x7227ddab {:status :ready, :val {:db-before 

[:find ?tx .
 :where [?a :artist/name "The Rolling Stones" ?tx]]

[[:db/retract :person/address :db/noHistory false]
 [:db/add :db.part/db :db.alter/attribute :person/address]]

;; schema for entity:
[{:db/id #db/id[:db.part/db]
  :db/ident :some-set/items
  :db/valueType :db.type/ref
;  :db/unique :db.unique/value
;  :db/unique :db.unique/identity
  :db/cardinality :db.cardinality/many
  :db/fulltext true
  :db/doc "List of all items included in this set."
  :db.install/_attribute :db.part/db}]

;; enums:
[{:db/id #db/id[:db.part/user] :db/ident :enum/a}
 {:db/id #db/id[:db.part/user] :db/ident :enum/b}
 {:db/id #db/id[:db.part/user] :db/ident :enum/c}]

;; trying to create 2 sets:
'[{:db/id #db/id[:db.part/user -1] :some-set/items [:enum/a :enum/b]}
  {:db/id #db/id[:db.part/user -2] :some-set/items [:enum/a :enum/c]}]

:db.error/unique-conflict Unique conflict: :some-set/items, value: 17592186045438 already held by: 17592186045482 asserted for: 17592186045484

you cannot add :enum/a to a new :some-set/items, because :enum/a is already used in existing :some-set/items

:some/things [:enum/a :enum/b [:enum/a :enum/c] :enum/d]

:some/things [:enum/a :enum/b {:some-set/items [:enum/a :enum/c]} :enum/d]

:db/unique :db.unique/value
:db/unique :db.unique/identity

(d/pull (d/db conn) '[*] 17592186045418)
;{:db/id 17592186045418
; :person/aliases ["Bert" "Bobby" "Curly" "Robert" "Robin”]}

@(d/transact conn [[:db/add 17592186045418 :person/aliases "Robert"]])
;{:db-after 

[com.datomic/datomic-pro "0.9.5206" :exclusions [joda-time]]
[postgresql "9.3-1102.jdbc41"]

(def uri "datomic:)
(def conn (d/connect uri))

java.sql.SQLException: No suitable driver
clojure.lang.Compiler$CompilerException: java.sql.SQLException: No suitable driver, compiling:(server.clj:28:11)

[a]
[b]
[c]
[a b]
[a c]
[b c]
[a b c]

{:db/id 1
 :person/aliases [:names/Bert :names/Bobby]}
{:db/id 2
 :person/aliases [:names/Bert :names/Curly]}

(d/create-database "datomic:")
@(d/transact (d/connect "datomic:")
           [{:db/id (d/tempid :db.part/user)
             :thisthing/doestnexist 0}])

(d/tempid :db.part/user)
; 

$ cat README-CONSOLE.md 
...
If you downloaded Console as a separate download (i.e.: not bundled with Datomic Pro), you will need to install it alongside Datomic:
Run this command from the directory you unzipped Console to:
    bin/install-console path-to-datomic-directory
Switch to your Datomic directory and run:
    bin/console -p 8080 alias transactor-uri-no-db
...

[Loaded org.postgresql.Driver from file:/var/lib/openshift/542fae5ae0b8cda9b7000ca0/app-root/data/datomic-pro-0.9.5153/lib/postgresql-9.3-1102-jdbc41.jar]

bin/datomic -Xmx512m -Xms512m backup-db 'datomic:sql://<DBNAME>?jdbc:postgresql://<IP>:5432?user=datomic&password=datomic' file:/var/lib/openshift/.../app-root/data/backup